UPDATE actionablealerts SET module = 'Donor Awards' where UPPER(type) = 'DONOR AWARD ENDING';
UPDATE actionablealerts SET module = 'Partner Monitoring' where UPPER(type) = 'FINANCIAL REPORT PAST DUE';
UPDATE actionablealerts SET module = 'Partner Monitoring' where UPPER(type) = 'NARRATIVE REPORT PAST DUE';
UPDATE actionablealerts SET module = 'Projects and Grants' where UPPER(type) = 'NO PROJECT PAYMENT REQUEST ACTIVITY';
UPDATE actionablealerts SET module = 'Projects and Grants' where UPPER(type) = 'NO PARTNER GRANT PAYMENT REQUEST ACTIVITY';
UPDATE actionablealerts SET module = 'Payment Processing' where UPPER(type) = 'OVERDUE PAYMENT REQUEST';
UPDATE actionablealerts SET module = 'Projects and Grants' where UPPER(type) = 'PARTNER GRANT SIGNATURE NOT RECEIVED';
UPDATE actionablealerts SET module = 'Payment Processing' where UPPER(type) = 'REJECTED PAYMENT REQUEST';
GO